Excel 2010 - Trendlines, Sparklines, Dual Axes, Chart Templates and Data Analysis Tools
      The "Excel 2010 - Trendlines, Sparklines, Dual Axes, Chart Templates and Data Analysis Tools" lesson covers the following topics:
  • Trendlines and Sparklines
  • Dual Axes and Chart Templates
  • Data Analysis Tools
      
      Trendlines and Sparklines      
      Upon successful completion you will be able to:

1. Understand Trendlines;
2. Add a Trendline to a Data Series;
3. Format Trendlines;
4. Remove Trendlines;
5. Use Trendline Forecasting;
6. Identify Other Trend Methods;
7. Add Sparklines;
8. Remove Sparklines.
      
      Dual Axes and Chart Templates      
      Upon successful completion you will be able to:

1. Add a Second Chart Axis;
2. Change Marker Colours;
3. Save Chart Templates;
4. Apply Chart Templates
5. Apply Templates to Existing Charts.		      
      Data Analysis Tools      
      Upon successful completion you will be able to:

1. Name Variable Cells;
2. Create Scenarios;
3. Select Scenario Variables;
4. Delete Scenarios;
5. Edit Scenarios;
6. Create Summary Reports;
7. Use Data Tables;
8. Use Goal Seek.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2010 - Trendlines, Sparklines, Dual Axes, Chart Templates and Data Analysis Tools :
Program Training Courses - Microsoft Excel 2010 :
Office Suite Training Courses - Microsoft Office 2010 :
© 2017 Online Training Masters